Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Views of Cached OLAP Catalog Metadata

The Metadata Reader Views for the OLAP Catalog, named with the prefix `MRV_OLAP2`, present a read API to a set of cache tables for OLAP Catalog metadata. These views and tables are structured to facilitate query performance for the OLAP API.

The `MRV_OLAP2` views correspond to the `ALL_OLAP2` views, which provide information about OLAP Catalog metadata. Each `MRV_OLAP2` view has the same name and column structure as its corresponding `ALL_OLAP2` view. If you require fast access to OLAP Catalog metadata, you should query the cached metadata through the `MRV_OLAP2` views.

The cache tables are not automatically refreshed when changes are made to the metadata. To refresh the cache, call the `CWM2_OLAP_METADATA_REFRESH.MR_REFRESH` procedure.

Note: If your data is stored in relational tables (not in analytic workspaces), you must refresh the OLAP Catalog metadata cache for applications that use the OLAP API.